1. Home
  2. Import Content in WordPress & WooCommerce with Excel
  3. 4.4 (latest)
  4. Code
  5. Classes
  6. Worksheet

PhpOffice\PhpSpreadsheet\Worksheet\Worksheet D

Total Complexity 500
Dependencies 47
Dependents 80
Total lines 3,714
Lines of code 1,687
Logical lines of code 1,004
Comment lines 447
Methods 190
Properties 53
Classes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php:35-3748

Methods 190

Method Rating Maintainability Complexity Lines of code
calculateColumnWidths()
C
 35 23 81
rangeToArrayYieldRows()
B
 40 19 54
setTitle()
A
 45 14 41
__clone()
A
 45 14 41
freezePane()
A
 45 11 43
getWorksheetAndCoordinate()
A
 46 11 35
setCodeName()
A
 48 11 32
fromArray()
A
 50 9 30
validateNamedRange()
A
 51 9 27
mergeCells()
A
 48 8 33
setSelectedCellsActivePane()
A
 56 9 17
createNewCell()
A
 50 8 28
clearMergeCellsByRow()
S
 53 7 22
clearMergeCellsByColumn()
S
 53 7 21
duplicateConditionalStyle()
S
 54 7 19
shrinkRangeToFit()
S
 53 6 24
duplicateStyle()
S
 53 6 21
getComment()
S
 56 6 18
checkSheetCodeName()
S
 56 6 17
buildNullRow()
S
 59 6 13
extractSheetTitle()
S
 60 6 12
removeRow()
S
 53 5 22
cellToArray()
S
 56 5 19
getConditionalStyles()
S
 58 5 16
isCellInSpillRange()
S
 58 5 16
removeComment()
S
 59 5 14
isCellLocked()
S
 59 5 14
removeColumn()
S
 53 4 23
garbageCollect()
S
 55 4 19
removeColumnDimensions()
S
 57 4 17
removeRowDimensions()
S
 58 4 16
copyCells()
S
 57 4 16
calculateArrays()
S
 63 5 10
conditionalStylesExists()
S
 60 4 13
getConditionalRange()
S
 60 4 13
mergeCellBehaviour()
S
 60 4 13
getChartByIndex()
S
 61 4 13
getXfIndex()
S
 61 4 12
setBreak()
S
 61 4 11
setSelectedCells()
S
 59 3 15
applyStylesFromArray()
S
 60 3 14
getBreaks()
S
 60 3 14
unmergeCells()
S
 60 3 13
rebindParent()
S
 61 3 13
namedRangeToArray()
S
 59 3 13
setBackgroundImage()
S
 61 3 12
getColumnDimension()
S
 63 3 11
protectCells()
S
 65 3 8
setAutoFilter()
S
 65 3 9
getTableIndexByName()
S
 65 3 9
setPaneState()
S
 63 3 9
getChartByName()
S
 67 3 8
getHashCode()
S
 67 3 7
getCoordinates()
S
 66 3 9
checkSheetTitle()
S
 64 3 9
__construct()
S
 56 1 18
removeTableByName()
S
 68 2 7
rangeToArray()
S
 67 2 7
getTableByName()
S
 74 2 4
disconnectCells()
S
 68 2 8
usesPanes()
S
 79 2 3
setPane()
S
 70 2 6
setActivePane()
S
 74 2 4
setXSplit()
S
 67 2 7
setYSplit()
S
 67 2 7
insertNewRowBefore()
S
 64 2 9
insertNewColumnBefore()
S
 64 2 9
insertNewColumnBeforeByIndex()
S
 70 2 6
getParentOrThrow()
S
 71 2 6
refreshRowDimensions()
S
 67 2 8
getProtectedCells()
S
 68 2 7
refreshColumnDimensions()
S
 67 2 8
getChartByNameOrThrow()
S
 68 2 7
getChartNames()
S
 69 2 7
getHyperlink()
S
 69 2 7
setHyperlink()
S
 67 2 8
getDataValidation()
S
 69 2 7
setDataValidation()
S
 67 2 8
getTabColor()
S
 71 2 6
isEmptyRow()
S
 64 2 10
isEmptyColumn()
S
 64 2 10
isRowVisible()
S
 78 2 3
isCellHiddenOnFormulaBar()
S
 71 2 6
getTableNames()
S
 69 2 7
removeColumnByIndex()
S
 70 2 6
unprotectCells()
S
 65 2 9
getRowDimension()
S
 68 2 7
getCell()
S
 63 2 10
getHighestColumn()
S
 71 2 6
getHighestRow()
S
 71 2 6
getCellOrNull()
S
 72 2 6
calculateWorksheetDataDimension()
S
 79 1 3
getChartCount()
S
 80 1 3
getRowBreaks()
S
 72 1 5
getParent()
S
 82 1 3
getHyperlinkCollection()
S
 82 1 3
hyperlinkExists()
S
 79 1 3
removeConditionalStyles()
S
 75 1 4
getConditionalStylesCollection()
S
 82 1 3
getChartCollection()
S
 82 1 3
addChart()
S
 73 1 5
getColumnIterator()
S
 79 1 3
calculateWorksheetDimension()
S
 79 1 3
getRowIterator()
S
 79 1 3
toArray()
S
 67 1 7
getRightToLeft()
S
 82 1 3
setCellValueExplicit()
S
 72 1 5
setCellValue()
S
 72 1 5
setRightToLeft()
S
 77 1 4
getHighestRowAndColumn()
S
 81 1 3
getHighestDataRow()
S
 80 1 3
setConditionalStyles()
S
 75 1 4
getDataValidationCollection()
S
 82 1 3
dataValidationExists()
S
 79 1 3
nameRequiresQuotes()
S
 78 1 3
__destruct()
S
 72 1 5
getCellCollection()
S
 82 1 3
getInvalidCharacters()
S
 80 1 3
getRowDimensions()
S
 82 1 3
getBackgroundExtension()
S
 82 1 3
getBackgroundMime()
S
 82 1 3
getBackgroundImage()
S
 82 1 3
getDefaultRowDimension()
S
 82 1 3
getColumnDimensions()
S
 72 1 5
getColumnDimensionByColumn()
S
 80 1 3
hasCodeName()
S
 80 1 3
getSelectedCells()
S
 82 1 3
getCodeName()
S
 82 1 3
columnDimensionCompare()
S
 79 1 3
getDefaultColumnDimension()
S
 82 1 3
getStyles()
S
 82 1 3
getStyle()
S
 70 1 6
copy()
S
 81 1 3
isTabColorSet()
S
 80 1 3
resetTabColor()
S
 77 1 4
cellExists()
S
 72 1 5
getDrawingCollection()
S
 82 1 3
setSelectedCell()
S
 80 1 3
getTitle()
S
 82 1 3
getActiveCell()
S
 82 1 3
getHeaderFooter()
S
 82 1 3
getActivePane()
S
 82 1 3
getPanes()
S
 82 1 3
setProtection()
S
 74 1 5
getPane()
S
 79 1 3
getProtection()
S
 82 1 3
setPaneTopLeftCell()
S
 77 1 4
getPaneTopLeftCell()
S
 82 1 3
getTopLeftCell()
S
 82 1 3
unfreezePane()
S
 80 1 3
setTopLeftCell()
S
 77 1 4
getFreezePane()
S
 82 1 3
getHighestDataColumn()
S
 80 1 3
removeTableCollection()
S
 76 1 4
getMergeCells()
S
 82 1 3
setHeaderFooter()
S
 77 1 4
setMergeCells()
S
 77 1 4
setSheetView()
S
 77 1 4
addTable()
S
 73 1 5
getTableCollection()
S
 82 1 3
removeAutoFilter()
S
 77 1 4
getSheetView()
S
 82 1 3
getAutoFilter()
S
 82 1 3
getXSplit()
S
 82 1 3
getYSplit()
S
 82 1 3
getProtectedCellRanges()
S
 82 1 3
getPrintGridlines()
S
 82 1 3
getSheetState()
S
 82 1 3
setComments()
S
 77 1 4
getComments()
S
 82 1 3
setShowSummaryRight()
S
 77 1 4
getShowSummaryRight()
S
 82 1 3
setShowSummaryBelow()
S
 77 1 4
getShowSummaryBelow()
S
 82 1 3
setShowRowColHeaders()
S
 77 1 4
getShowRowColHeaders()
S
 82 1 3
setPrintGridlines()
S
 77 1 4
setShowGridlines()
S
 77 1 4
getPaneState()
S
 82 1 3
getShowGridlines()
S
 82 1 3
columnDimensionExists()
S
 79 1 3
setSheetState()
S
 77 1 4
getPageSetup()
S
 82 1 3
setPageSetup()
S
 77 1 4
getPageMargins()
S
 82 1 3
compareRowBreaks()
S
 72 1 5
compareColumnBreaks()
S
 72 1 5
getColumnBreaks()
S
 72 1 5
setPageMargins()
S
 77 1 4
rowDimensionExists()
S
 79 1 3